Name |
|
Code |
|
Comment |
Opakowanie leku |
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Flaga aktywnosci w systemie |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
Yes |
Comment |
Ilosc |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
ID jednostki miary |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
ID jednostki opakowania |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Kod EAN (kod kreskowy) |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Numer BAZYL |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Numer BLOZ |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Numer rejestru Unii Europejskiej |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Status opakowania |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Flaga usuniecia |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Definicja porcji |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID jednostki definicji porcji |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Ilosc skladnika aktywnego w porcji |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID jednostki ilosci skladnika aktywnego w porcji |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Typ ceny |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data ustalenia ceny |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Flaga refundacji leku |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Limit porcji |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Limit opakowania |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
ID stawki VAT |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID ze slownika JWC |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
ID ze slownika BAZYL |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Opis |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data wpisania leku do rejestru |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Nazwa rejestru |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Numer rejestru |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Produkt dopuszczony do obrotu |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Opakowanie szpitalne |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Cena urzedowa zbytu |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Cena urzedowa hurt |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Cena urzedowa detal |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Cena limitu |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Cena maksymalna |
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
Skrót z pól rekordu |
Name |
|
Code |
|
Data Type |
VARCHAR2(12) |
Mandatory |
No |
Comment |
Zewnetrzny identyfikator |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
|
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|